In situations where the direct use of the JDBC connection is not possible, transaction statements can be used to control a local transaction.
START TRANSACTION- synonym for connection.setAutoCommit(false)
COMMIT- synonym for connection.setAutoCommit(true)
ROLLBACK- synonym for connection.rollback() and returning to auto commit mode.